
-- ID_INTEGRACAO_GOVERNO - CHAVE ESTRANGEIRA DA TABELA LF_LX_INTEGRACAO_GOVERNO

CREATE TABLE LF_INF_COMPLEMENTAR ( ID_INF_COMPLEMENTAR                INT NOT NULL,
                                                                       ID_INTEGRACAO_GOVERNO            SMALLINT NOT NULL,
                                                                       COD_FILIAL                                CHAR(6) NOT NULL,      
                                                                       DATA_INICIAL                              DATETIME NOT NULL,
                                                                       DATA_FINAL                                DATETIME NOT NULL,
                                                                       NOME_OBJETO                               VARCHAR(50) NOT NULL,
                                                                       VALOR_OBJETO                              VARCHAR(100) NOT NULL, 
 CONSTRAINT [XPKLF_INF_COMPLEMENTAR] PRIMARY KEY CLUSTERED 
(
      [ID_INF_COMPLEMENTAR] ASC
) ON [PRIMARY]                                                                    )

CREATE UNIQUE NONCLUSTERED INDEX [XAK1LF_INF_COMPLEMENTAR] ON [dbo].[LF_INF_COMPLEMENTAR] 
(
      [ID_INTEGRACAO_GOVERNO] ASC,
      [COD_FILIAL] ASC,
      [DATA_INICIAL] ASC,
      [DATA_FINAL] ASC,
      [NOME_OBJETO] ASC 
) ON [PRIMARY]
